Excel Cheat Sheet

Central Tendency


\(\rightarrow\) To compute the mean of data use the formula 

=AVERAGE([data set])

You can enter [data set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.


\(\rightarrow\)  To compute the median of data use the formula

=MEDIAN([data set])

You can enter [data set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.


\(\rightarrow\)  To compute the mode of data use the formula

=MODE([data set])

You can enter [data set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.


\(\rightarrow\)  To compute the weighted mean of data, first create a column of your data and put the weight in the adjacent column, and you can use the formula 

=SUM([data set]*[weight set])/SUM([weight set])

You can enter [data set] and [weight set] by putting in the range e.g. A2:A16 or just click and highlight all of the data while writing the equation.